<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="Checking the Storage Location of Cluster Data">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002199998065.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="">
  <meta name="DC.Publisher" content="20250306">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="EN-US_TOPIC_0000002164756998">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>Checking the Storage Location of Cluster Data</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="EN-US_TOPIC_0000002164756998"></a><a name="EN-US_TOPIC_0000002164756998"></a>
  <h1 class="topictitle1">Checking the Storage Location of Cluster Data</h1>
  <div>
   <p>In Oracle cluster backup and restoration scenarios, cluster data must be stored in ASM. Otherwise, backup and restoration jobs may fail. This section describes how to check the storage location of cluster data. Skip this section in non-cluster scenarios.</p>
   <div class="section">
    <h4 class="sectiontitle">Procedure</h4>
    <ol>
     <li><span>Log in to the Oracle database host.</span><p></p>
      <ul id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597202_en-us_topic_0000001656760969_ul1983714162204">
       <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597202_en-us_topic_0000001656760969_li7258697580">If the Linux OS is used, use PuTTY to log in to the Oracle database host and run the <strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597202_b14682476107">su - oracle</strong> command to switch to user <strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597202_b1646874718106">oracle</strong>.</li>
       <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597202_en-us_topic_0000001656760969_li1366015032013">If the Windows OS is used, log in to the Oracle database host as the system administrator.</li>
      </ul> <p></p></li>
     <li><span>Run the following commands to log in to the Oracle database instance.</span><p></p>
      <ul id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_ul7420345341">
       <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li15682124913711">OS authentication:
        <ul id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_ul89443983816">
         <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li18420124173415">If the Linux OS is used, run the following commands:<p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p95148598366"><a name="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li18420124173415"></a><a name="en-us_topic_0000002164597290_li18420124173415"></a><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b14236563719">export ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_i85144598369">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p145141259153613"><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b1597618293715">sqlplus / as sysdba</strong></p></li>
         <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li7402151163816">If the Windows OS is used, perform the following operations:
          <ol type="a" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_ol124110408264">
           <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li624120402267">Press <span class="uicontrol" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_en-us_topic_0000002164597290_uicontrol11819941114510"><b>Win+R</b></span> to open the <strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_en-us_topic_0000002164597290_b1015191219408">Run</strong> window.</li>
           <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li161821338277">Enter <span class="parmvalue" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_parmvalue122291222476"><b>cmd</b></span> and run the following commands:<p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p1755152313372"><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b19591532143713">set ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_i16755423133718">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p1075515234379"><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b540852910371">sqlplus / as sysdba</strong></p></li>
          </ol></li>
        </ul></li>
       <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li105571236103417">Database authentication:
        <ul id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_ul1136516538386">
         <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li1723334817382">If the Linux OS is used, run the following commands:<p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p920984963717"><a name="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li1723334817382"></a><a name="en-us_topic_0000002164597290_li1723334817382"></a><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b162511338427">export ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_i142521037423">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p182093496371"><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b034785743716">sqlplus</strong></p> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p17915722412">Enter the name of a user with the <strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b0440649114212">sysdba</strong> permissions as prompted:</p> <pre class="screen" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_screen9915112104114"><em id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_i1915102164113">username </em>as sysdba</pre> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p159150224117">Enter the password as prompted.</p></li>
         <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li122822426407">If the Windows OS is used, perform the following operations:
          <ol type="a" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_ol587720252273">
           <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li5168124414479">Press <span class="uicontrol" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_en-us_topic_0000002164597290_uicontrol11819941114510_1"><b>Win+R</b></span> to open the <strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_en-us_topic_0000002164597290_b1015191219408_1">Run</strong> window.</li>
           <li id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_li3877172517270">Enter <span class="parmvalue" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_parmvalue89061315114212"><b>cmd</b></span> and run the following commands:<p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p8745723103813"><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b0361183517422">set ORACLE_SID=</strong><em id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_i8361163518426">Database instance name</em></p> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p15745182333814"><strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b11154427163811">sqlplus</strong></p> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p71274192512">Enter the name of a user with the <strong id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_b330420012221">sysdba</strong> permissions as prompted:</p> <pre class="screen" id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_screen18896121620243"><em id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_i380114413256">username </em>as sysdba</pre> <p id="EN-US_TOPIC_0000002164756998__en-us_topic_0000002164597290_p15251105852511">Enter the password as prompted.</p></li>
          </ol></li>
        </ul></li>
      </ul> <p></p></li>
     <li><span>Run the following command to check the storage location of cluster data:</span><p></p><p><strong>select name from v$datafile;</strong></p> <p>If all paths start with <strong>+</strong>, cluster data is stored in ASM, and backup and restoration are supported. Otherwise, backup and restoration are not supported.</p> <p></p></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="en-us_topic_0000002199998065.html">Step 1: Checking and Configuring the Database Environment</a>
    </div>
   </div>
  </div>
 </body>
</html>